How to: Set both horizontal and vertical page breaks in a worksheet.
Solution:
Select the cell just below and just right of where the breaks are to be inserted and select 'Page Break' from the 'Insert' menu.
1) Select (click on) the cell just below and just right of where the breaks are to be inserted. (The cell is highlighted.)
2) Select the 'Insert' menu and select 'Page Break'. (The worksheet is split into separate pages at the breaks.)
NOTE: The breaks are inserted along the top and left sides of a selected cell. Manual page breaks are fixed and appear on the screen as dashed lines. Automatic page breaks automatically adjust when manual page breaks are inserted into a worksheet. Automatic page breaks appear as dotted lines.
